    create table jms_dm.dm_cusc_tyd_taking_customer_summary_dt
(
    proxy_area_code   varchar(50) comment '代理区code',
    pick_network_code varchar(50) comment '取件网点code',
    customer_code     varchar(50) comment '客户编号code',
    proxy_area_name   varchar(100) comment '代理区名称',
    pick_network_name varchar(100) comment '取件网点名称',
    customer_name     varchar(100) comment '客户编号名称',
    order_source_code varchar(50) comment '订单来源code',
    order_source_name varchar(100) comment '订单来源名称',
    order_total       int comment '订单票数',
    taking_num        int comment '已揽收票数	',
    date_time         date comment '日期'
) ENGINE = OLAP DUPLICATE KEY(proxy_area_code, pick_network_code, customer_code)
COMMENT "兔优达揽收-汇总"
PARTITION BY RANGE(date_time)
(START ("2022-08-15") END ("2022-09-15") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(customer_code) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);
